package cn.example.easy_excel_demo.module.domain.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import lombok.*;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;


@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@Builder
@HeadFontStyle(fontName = "微软雅黑",fontHeightInPoints = 11,bold = false)//表头字体样式
@HeadRowHeight(value = 25)//表头行高
@ContentFontStyle(fontName = "微软雅黑",fontHeightInPoints = 11)//内容字体样式
@ContentRowHeight(value = 30)//内容行高
@ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER,verticalAlignment = VerticalAlignment.CENTER)//内容样式
public class UserVO {
    @ExcelProperty(value = "编号",index = 0)
    private Long id;
    @ExcelProperty(value = "用户名",index = 1)
    private String username;
    @ExcelProperty(value = "用户密码",index = 2)
    private String password;
    @ExcelProperty(value = "性别",index = 3)
    private String sex;
    @ExcelProperty(value = "电话号码",index = 4)
    private String call;
    @ExcelProperty(value = "身份证号",index = 5)
    private String idCard;
    @ExcelProperty(value = "居住地址",index = 6)
    private String address;
}
